﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace ZhongheCms.Models
{
    public partial class GswTblJob
    {
        public static List<GswTblJob> GetJobList(string title, string funcId, int cusid)
        {
            var strSql = "select * from GswTblJob where FunctionId='" + funcId + "' and CustomerId=" + cusid;

            if (!string.IsNullOrWhiteSpace(title))
            {
                strSql += " and  JobTitle like '%" + title + "%' ";
            }

            strSql += " order by Id desc";

            return Fetch(strSql);
        }
    }


   
    
}